﻿CREATE TABLE [dbo].[User] (
    [uname]    NVARCHAR (15) NOT NULL,
    [name]     NVARCHAR (15) NOT NULL,
    [lastName] NVARCHAR (15) NOT NULL,
    [password] NVARCHAR (10) NOT NULL,
    [email]    NVARCHAR (15) NOT NULL,
    [forumId]  INT           NOT NULL,
    [friends]  NVARCHAR (MAX) NOT NULL,
    PRIMARY KEY CLUSTERED ([uname] ASC), 
    FOREIGN KEY (forumId) REFERENCES [Forum]([id])
);

